1 <?php
2 session_start();
3 include('includes/config.php');
4 if(strlen($_SESSION['alogin'])==0)
5 {
6 header('location:index.php');
7 }
8 else{
9 ?>
10 <!DOCTYPE HTML>
11 <html>
12 <head>
13 <title>TMS | Admin Dashboard</title>
14 <meta name="viewport" content="width=device-width, initial-scale=1">
15 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
16 <script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
17 <!-- Bootstrap Core CSS -->
18 <link href="css/bootstrap.min.css" rel='stylesheet' type='text/css' />
19 <!-- Custom CSS -->
20 <link href="css/style.css" rel='stylesheet' type='text/css' />
21 <link rel="stylesheet" href="css/morris.css" type="text/css"/>
22 <!-- Graph CSS -->
23 <link href="css/font-awesome.css" rel="stylesheet">
24 <!-- jQuery -->
25 <script src="js/jquery-2.1.4.min.js"></script>
26 <!-- //jQuery -->
27 <link href='//fonts.googleapis.com/css?family=Roboto:700,500,300,100italic,100,400' rel='stylesheet' type='text/css'/>
28 <link href='//fonts.googleapis.com/css?family=Montserrat:400,700' rel='stylesheet' type='text/css'>
29 <!-- lined-icons -->
30 <link rel="stylesheet" href="css/icon-font.min.css" type='text/css' />
31 <!-- //lined-icons -->
32 </head>
33 <body>
34 <div class="page-container">
35 <!--/content-inner-->
36 <div class="left-content">
37 <div class="mother-grid-inner">
38 <!--header start here-->
39 <?php include('includes/header.php');?>
40 <!--header end here-->
41 <ol class="breadcrumb">
42 <li class="breadcrumb-item"><a href="index.html">Home</a> <i class="fa fa-angle-right"></i></li>
43 </ol>
44 <!--four-grids here-->
45 <div class="four-grids">
46 <div class="col-md-3 four-grid">
47 <div class="four-agileits">
48 <div class="icon">
49 <i class="glyphicon glyphicon-user" aria-hidden="true"></i>
50 </div>
51 <div class="four-text">
52 <h3>User</h3>
53
54 <?php $sql = "SELECT id from tblusers";
55 $query = $dbh -> prepare($sql);
56 $query->execute();
57 $results=$query->fetchAll(PDO::FETCH_OBJ);
58 $cnt=$query->rowCount();
59 ?> <h4> <?php echo htmlentities($cnt);?> </h4>
60
61
62 </div>
63
64 </div>
65 </div>
66 <div class="col-md-3 four-grid">
67 <div class="four-agileinfo">
68 <div class="icon">
69 <i class="glyphicon glyphicon-list-alt" aria-hidden="true"></i>
70 </div>
71 <div class="four-text">
72 <h3>Bookings</h3>
73 <?php $sql1 = "SELECT BookingId from tblbooking";
74 $query1 = $dbh -> prepare($sql1);
75 $query1->execute();
76 $results1=$query1->fetchAll(PDO::FETCH_OBJ);
77 $cnt1=$query1->rowCount();
78 ?>
79 <h4><?php echo htmlentities($cnt1);?></h4>
80
81 </div>
82
83 </div>
84 </div>
85 <div class="col-md-3 four-grid">
86 <div class="four-w3ls">
87 <div class="icon">
88 <i class="glyphicon glyphicon-folder-open" aria-hidden="true"></i>
89 </div>
90 <div class="four-text">
91 <h3>Enquiries</h3>
92 <?php $sql2 = "SELECT id from tblenquiry";
93 $query2= $dbh -> prepare($sql2);
94 $query2->execute();
95 $results2=$query2->fetchAll(PDO::FETCH_OBJ);
96 $cnt2=$query2->rowCount();
97 ?>
98 <h4><?php echo htmlentities($cnt2);?></h4>
99
100 </div>
101
102 </div>
103 </div>
104 <div class="col-md-3 four-grid">
105 <div class="four-wthree">
106 <div class="icon">
107 <i class="glyphicon glyphicon-briefcase" aria-hidden="true"></i>
108 </div>
109 <div class="four-text">
110 <h3>Toatal packages</h3>
111 <?php $sql3 = "SELECT PackageId from tbltourpackages";
112 $query3= $dbh -> prepare($sql3);
113 $query3->execute();
114 $results3=$query3->fetchAll(PDO::FETCH_OBJ);
115 $cnt3=$query3->rowCount();
116 ?>
117 <h4><?php echo htmlentities($cnt3);?></h4>
118
119 </div>
120
121 </div>
122 </div>
123 <div class="clearfix"></div>
124 </div>
125
126 <div class="four-grids">
127 <div class="col-md-3 four-grid">
128 <div class="four-w3ls">
129 <div class="icon">
130 <i class="glyphicon glyphicon-folder-open" aria-hidden="true"></i>
131 </div>
132 <div class="four-text">
133 <h3>Issues Riaised</h3>
134 <?php $sql5 = "SELECT id from tblissues";
135 $query5= $dbh -> prepare($sql5);
136 $query5->execute();
137 $results5=$query5->fetchAll(PDO::FETCH_OBJ);
138 $cnt5=$query5->rowCount();
139 ?>
140 <h4><?php echo htmlentities($cnt5);?></h4>
141
142 </div>
143
144 </div>
145 </div>
146
147
148 <div class="clearfix"></div>
149 </div>
150 <!--//four-grids here-->
151
152
153 <div class="inner-block">
154
155 </div>
156 <!--inner block end here-->
157 <!--copy rights start here-->
158 <?php include('includes/footer.php');?>
159 </div>
160 </div>
161
162 <!--/sidebar-menu-->
163 <?php include('includes/sidebarmenu.php');?>
164 <div class="clearfix"></div>
165 </div>
166 <script>
167 var toggle = true;
168
169 $(".sidebar-icon").click(function() {
170 if (toggle)
171 {
172 $(".page-container").addClass("sidebar-collapsed").removeClass("sidebar-collapsed-back");
173 $("#menu span").css({"position":"absolute"});
174 }
175 else
176 {
177 $(".page-container").removeClass("sidebar-collapsed").addClass("sidebar-collapsed-back");
178 setTimeout(function() {
179 $("#menu span").css({"position":"relative"});
180 }, 400);
181 }
182
183 toggle = !toggle;
184 });
185 </script>
186 <!--js -->
187 <script src="js/jquery.nicescroll.js"></script>
188 <script src="js/scripts.js"></script>
189 <!-- Bootstrap Core JavaScript -->
190 <script src="js/bootstrap.min.js"></script>
191 <!-- /Bootstrap Core JavaScript -->
192 <!-- morris JavaScript -->
193 <script src="js/raphael-min.js"></script>
194 <script src="js/morris.js"></script>
195 <script>
196 $(document).ready(function() {
197 //BOX BUTTON SHOW AND CLOSE
198 jQuery('.small-graph-box').hover(function() {
199 jQuery(this).find('.box-button').fadeIn('fast');
200 }, function() {
201 jQuery(this).find('.box-button').fadeOut('fast');
202 });
203 jQuery('.small-graph-box .box-close').click(function() {
204 jQuery(this).closest('.small-graph-box').fadeOut(200);
205 return false;
206 });
207
208 //CHARTS
209 function gd(year, day, month) {
210 return new Date(year, month - 1, day).getTime();
211 }
212
213 graphArea2 = Morris.Area({
214 element: 'hero-area',
215 padding: 10,
216 behaveLikeLine: true,
217 gridEnabled: false,
218 gridLineColor: '#dddddd',
219 axes: true,
220 resize: true,
221 smooth:true,
222 pointSize: 0,
223 lineWidth: 0,
224 fillOpacity:0.85,
225 data: [
226 {period: '2014 Q1', iphone: 2668, ipad: null, itouch: 2649},
227 {period: '2014 Q2', iphone: 15780, ipad: 13799, itouch: 12051},
228 {period: '2014 Q3', iphone: 12920, ipad: 10975, itouch: 9910},
229 {period: '2014 Q4', iphone: 8770, ipad: 6600, itouch: 6695},
230 {period: '2015 Q1', iphone: 10820, ipad: 10924, itouch: 12300},
231 {period: '2015 Q2', iphone: 9680, ipad: 9010, itouch: 7891},
232 {period: '2015 Q3', iphone: 4830, ipad: 3805, itouch: 1598},
233 {period: '2015 Q4', iphone: 15083, ipad: 8977, itouch: 5185},
234 {period: '2016 Q1', iphone: 10697, ipad: 4470, itouch: 2038},
235 {period: '2016 Q2', iphone: 8442, ipad: 5723, itouch: 1801}
236 ],
237 lineColors:['#ff4a43','#a2d200','#22beef'],
238 xkey: 'period',
239 redraw: true,
240 ykeys: ['iphone', 'ipad', 'itouch'],
241 labels: ['All Visitors', 'Returning Visitors', 'Unique Visitors'],
242 pointSize: 2,
243 hideHover: 'auto',
244 resize: true
245 });
246
247
248 });
249 </script>
250 </body>
251 </html>
252 <?php } ?>
